View INSERTs not returning OID in Postgres 7.2.1

Поиск
Список
Период
Сортировка
От Damon Cokenias
Тема View INSERTs not returning OID in Postgres 7.2.1
Дата
Msg-id p04310112b8da5fa05391@[10.0.1.9]
обсуждение исходный текст
Ответ на Re: Yet another indexing issue.  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: View INSERTs not returning OID in Postgres 7.2.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I recently moved from 7.1.3 to 7.2.1.  In doing so, my application broke.  It relies on INSERT returning the OID of the
insertedrow, even if the INSERT was on a view.  I saw a note in the 7.2.1 notes about fixing a problem in this area,
perhapsmore needs to be done? 

Example:

acropolis=# create table shad (a integer);
CREATE
acropolis=# create view shadview as select * from shad;
CREATE
acropolis=# create rule shadview_insert as on insert to shadview do instead insert into shad values (new.a);
CREATE

acropolis=# insert into shad values (1);
INSERT 3876425 1

acropolis=# insert into shadview values (2);
INSERT 0 0

acropolis=# select * from shad;
 a
---
 1
 2
(2 rows)

---------------

Shouldn't the second INSERT return an OID as well?

Thanks,

-Damon

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: refcursor returned by pl/psql to jdbc
Следующее
От: "Command Prompt, Inc."
Дата:
Сообщение: ANNOUNCE: Mammoth PostgreSQL